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.
Data
Finances
Numbers
All of the above
Rate this question:
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:
(A1:G50)
(A1, B3:C9)
(A1:B5:C5)
(A1:B5#C5)
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:
= (equal sign)
, (comma)
& (ampersand)
: (colon)
Rate this question:
CTRL+SHIFT+: (colon)
CTRL+; (semicolon)
CTRL+F10
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:
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:
Edit
Format
Help
File
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.
Excel 2007 Intermediate Course Short Quiz
This short quiz for the Excel 2007 Intermediate Course assesses key functionalities such as formula calculation, cell operations, and data management. It verifies understanding of...
Questions:
13 |
Attempts:
427 |
Last updated:
Mar 17, 2023
|
Excel 2007 (Pre Test)
The 'Excel 2007 (Pre Test)' assesses user proficiency in using Excel 2007, covering topics like addition of rows and columns, Goal Seek, function syntax, chart updating, cell...
Questions:
15 |
Attempts:
118 |
Last updated:
Mar 11, 2024
|
Spreadsheet Styles, Themes And Tables Quiz #6
Spreadsheet Styles, Themes and Tables Quiz #6 explores Excel 2007 features like Quick Styles, Live Preview, and custom cell formatting. It assesses understanding of interface...
Questions:
14 |
Attempts:
127 |
Last updated:
May 01, 2024
|
Excel 2007 Advanced Post Test
The 'Excel 2007 Advanced Post Test' assesses advanced skills in Excel 2007, including data formatting, cell content rotation, and use of the AutoSum feature. It is designed to...
Questions:
15 |
Attempts:
289 |
Last updated:
Mar 20, 2023
|
2nd Yr MS EXCEL 2007
Some people have had computers with them but are still unable to make maximum use of the excel sheet. As a second year student you should by now know how to use Microsoft...
Questions:
39 |
Attempts:
422 |
Last updated:
Sep 05, 2023
|
Computer Applications- Microsoft Excel: Microsoft Excel 2007 Basics
Explore the fundamentals of Microsoft Excel 2007, including interface navigation with the Office Button, understanding cells, rows, and columns, and data entry techniques. This...
Questions:
15 |
Attempts:
600 |
Last updated:
Apr 18, 2023
|
Wait!
Here's an interesting quiz for you.