This MS Excel 2007 Quiz tests your ability to perform basic tasks such as entering dates, summing columns, adjusting column widths, using Format Painter, and extending number sequences. It is designed to enhance productivity skills in Excel, crucial for data management and office administration.
Click Subtotals on the Data menu.
View the sum in the formula bar.
Click the AutoSum button on the Standard toolbar, then press ENTER.
Single-click the boundary to the left of the column heading.
Double-click the boundary to the right of the column heading.
Press ALT and single-click anywhere in the column.
Rate this question:
Use CTRL to select all three cells, then click the Paste button on the Standard toolbar
Copy the selected cell, then select the other two cells, click Style on the Format menu, then click Modify
Click Format Painter on the Formatting toolbar twice, then click in each cell you want to copy the formatting to.
Rate this question:
Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows.
Select the range you want, including both cells, point to Fill on the Edit menu, and then click Down.
Copy the second cell, click in the cell below it, on the Standard toolbar click the down arrow on the Paste button, and then click Paste Special.
Rate this question:
Edit
Format
Help
File
Rate this question:
Data
Finances
Numbers
All of the above
Rate this question:
=SUM(A1:A5)
Add A1 - A5
Subtract the numbers from A1 to A5
A1 = A5
Rate this question:
= (equal sign)
, (comma)
& (ampersand)
: (colon)
Rate this question:
To add all the data together using addition only
To tell the person viewing that this is a function and it should be added together
To calculate all the data correctly without any mistakes
To inform the computer that an arithmetic function will occur
Rate this question:
(A1:G50)
(A1, B3:C9)
(A1:B5:C5)
(A1:B5#C5)
Rate this question:
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.