The 'Excel 1 Final' quiz assesses proficiency in Excel, covering topics like cell referencing, chart creation, active cell indication, 3D referencing, and navigation techniques. It is designed to enhance practical skills in managing and analyzing data effectively.
True
False
Rate this question:
A darker wide border
A dotted border
A blinking border
None of the above
Rate this question:
The cell below the cell where you entered the data
The cell to the right of where you entered the data.
it will not move.
The formula bar so you can double-check your data.
Rate this question:
True
False
Rate this question:
B1-G10
B1.G10
B1;G10
B1:G10
Rate this question:
Display the importance of values over time emphasizing the amount of change
Display the individual values for comparison.
Display one data series as a whole. Each of its parts represents a percentage of the whole.
Show trends over time emphasizing time flow and rate of change.
Rate this question:
A portion of the spreadsheet where you type your formula.
The intersection of the row and column
The upper corner that is to the left of the column indicator and above the row indicator.
Any place on the spreadsheet where you can type.
Rate this question:
Hold down the CTRL key
hold down the SHIFT key
Hold down the ALT key
Hold down CTRL + SHIFT
Rate this question:
Double-click any cell in the column
Drag from the top cell in the column to the last cell in the column
Click the column heading
Click the column label
Rate this question:
True
False
Rate this question:
True
False
Rate this question:
Print Preview
Normal
Page Break Preview
Split View
Rate this question:
Enter
CTRL + Enter
Tab
Insert
Rate this question:
You can only change the font type and size for text data.
If you want to add decimal points to a number, your only choice is to use the format menu and then choose cells.
You can use the autoformat command to create a certain look and then customize it to your individual requirements.
When you use a “$”, it always appears left justified in the cell.
Adding a graphic to the spreadsheet
Reference in a formula to cels on other worksheets
A special kind of function that uses 3 numbers
Formatting with 3 colors.
Rate this question:
Right-click on the status bar and select SUM
Click the AutoCalculate button on the toolbar
Use the key combo CTRL + $
Double-click the selection
Rate this question:
The sum of values in the cell's column
Nothing until you select a range of cells
The sum of the cell's row unless you change the range
A formula which will add values in the range Excel guesses you want to add
Rate this question:
Nothing will print because some cells with data have been omitted
Only the cells with gray background will print
The whole sheet will print
Only the cells with white background will print.
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.
BASIC 6 COMPUTING QUIZ
The BASIC 6 COMPUTING QUIZ assesses foundational knowledge in spreadsheet management, focusing on Excel. It covers key concepts like cells, databases, sheet tabs, and cell naming,...
Questions:
8 |
Attempts:
122 |
Last updated:
Apr 06, 2023
|
Data Analyst Excel Test
Dive into our Data Analyst Excel Test and show off your skills. In this test, you'll face a range of challenges that cover everything essential for a data analyst. We'll...
Questions:
10 |
Attempts:
7779 |
Last updated:
Jul 03, 2024
|
9th Grade Excel Test
This 9th Grade Excel Test assesses key spreadsheet skills. It covers functions like MAX and RANGE, proper data selection for graphs, and understanding of cell alignment. Ideal for...
Questions:
9 |
Attempts:
1995 |
Last updated:
Nov 08, 2024
|
Keystone Bank Pre-Training Assessment
This assessment tests proficiency in Excel functionalities like sorting, using gridlines, worksheet operations, freeze panes, and functions.
Questions:
20 |
Attempts:
143 |
Last updated:
Mar 22, 2023
|
Microsoft Excel Proficiency Trivia Questions
This quiz is created to identify the proficiency of users about Microsoft Excel.
Questions:
122 |
Attempts:
227 |
Last updated:
Sep 13, 2023
|
Test How Much Do You Know About Excel Sheets! Trivia
Explore your knowledge of Excel Sheets with this trivia! Learn to sort columns, freeze panes, create tables, use conditional formatting, and search data efficiently. Perfect for...
Questions:
20 |
Attempts:
482 |
Last updated:
Sep 09, 2024
|
Wait!
Here's an interesting quiz for you.