MS Excel 2007 Midterm Exam Setb
50 Questions
| Attempts: 167
Cit midterm exam aug 16 - 17
Questions and Answers
- 1.
Identify no. 2 only
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
How many sheets are there by default in a worksheet
- 11.
What group insert row belongs
- A.
Cells
- B.
Alignment
- C.
Insert
Correct Answer
A. Cells -
- 12.
What group autosum belong
- A.
Editing
- B.
Home
- C.
Number
Correct Answer
A. Editing -
- 13.
What group text wrap belong
- A.
Home
- B.
Font
- C.
Alignment
Correct Answer
C. Alignment -
- 14.
Which tab cut, copy & paste belong
- A.
Home
- B.
Edit
- C.
Standard
Correct Answer
A. Home -
- 15.
Which tab margins belong
- A.
Home
- B.
Insert
- C.
Page lay out
Correct Answer
C. Page lay out -
- 16.
Combination of column and row coordinates
Correct Answer
cell address - 17.
Correct Answer
ms office button
office button
microsoft office button - 18.
Keyboard shortcuts:cut
Correct Answer
ctrl+x - 19.
Save as
Correct Answer
f12 - 20.
New
Correct Answer
ctrl+n - 21.
Go to
Correct Answer
f5 - 22.
Find and replace
Correct Answer
ctrl+f - 23.
Enter current date
Correct Answer
ctrl+; - 24.
Applies outline border to the selected cells
Correct Answer
ctrl+shift+& - 25.
Hides selected rows
Correct Answer
ctrl+9 - 26.
Unhides any hidden rows within the selection
Correct Answer
ctrl+shift+c - 27.
Date formate
Correct Answer
ctrl+shift+# - 28.
Strikethrough
Correct Answer
ctrl+5 - 29.
Edit active cell
Correct Answer
f2 - 30.
Moves to the beginning of a row in a worksheet
Correct Answer
home - 31.
Moves one screen up in a worksheet
Correct Answer
page up - 32.
Moves on cell to the right in a worksheet
Correct Answer
tab
arrow right
right arrow - 33.
Moves to the beginning of a current date region
Correct Answer
ctrl+home - 34.
Paste
Correct Answer
ctrl+v - 35.
Redo
Correct Answer
ctrl+y - 36.
One cell down
Correct Answer
enter
arrow down - 37.
Spelling & grammar
Correct Answer
f7 - 38.
Moves to the edge of the current data region
Correct Answer
ctrl+arrow key
ctrl+arrow right
ctrl+right arrow - 39.
Move to the last cell on a worksheet
Correct Answer
ctrl+end - 40.
Hides ribbon
Correct Answer
ctrl+f1 - 41.
Insert dialog box
Correct Answer
ctrl+shift+() - 42.
File extension of word 2007
Correct Answer
.docx - 43.
File extension of ms excel 2007
Correct Answer
.xlsx - 44.
Intersection of rows and columns
Correct Answer
cell
cells - 45.
Correct Answer
ms dialog box launcher
dialog box launcher
launcher - 46.
Electronic spreadsheet
Correct Answer
excel
ms excel
microsoft excel - 47.
Displays the name of a workbook
Correct Answer
title bar - 48.
Gives access to the commands you frequently used
Correct Answer
quick access toolbar
microsoft quick access toolbar - 49.
Number of columns in worksheet
Correct Answer
256 - 50.
Number of rows in a worksheet
Correct Answer
65536
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2022Quiz Edited by
ProProfs Editorial Team -
Aug 16, 2010Quiz Created by
Cutierich05
Back to top