NEW
Font size
WorksheetsModule [5] - Excel Exams
Total questions: 75
Worksheet time: 38mins
When you remove a filter, the original data is retrieved. Select one:
True
False
Select Landscape for vertical page. Select one:
True
False
To run a logical test, use ………………. Select one:
Sum function
IF function
Count function
Round function
Operations should be enclosed in parentheses. Select one:
True
False
When the column isn't wide enough to display the value, …………… appears. Select one:
#DIV/0! error
Error #NAME?
#VALUE! Error
Error ######
Excel displays the #DIV/0! Error when there is an empty cell. Select one:
True
False
To organize a list of names in an alphabetical order, use ……………. Select one:
Data mining
Data Filtering
Data sorting
Data applying
The worksheet direction cannot be changed. Select one:
True
False
Use conditional formatting to apply colors on cells. Select one:
True
False
To move one cell to left, press ………………. Select one:
Tab
Insert
Enter
Shift + Tab
To delete a cell content, press ………………. Select one:
remove
Delete
Enter
Shift
Error ##### means that the syntax of the formula should be corrected. Select one:
True
False
You can find different chart types in the …………… tab. Select one:
Data
Design
formulas
View
Filtering depends on the type of data. Select one:
True
False
To write a title in a cell consisting of several cells, press ……………… button. Select one:
Formulas
Wrap text
Merge and Center
Review
Excel displays the #REF! error when a formula refers to a cell that is not valid. Select one:
True
False
There are ……………… to be used for navigating through the worksheet. Select one:
eight tools
two tools
three tools
four tools
………………… means that the formula refers to a cell that is not valid. Select one:
#REF! error
Error #NAME?
#VALUE! Error
#DIV/0! error
Excel contains AutoFilter submenu boxes. Select one:
True
False
To write a title for the data, you can merge cells. Select one:
True
False
Data sorting is different from data analysis. Select one:
True
False
You can color the borders of the cells. Select one:
True
False
To calculate the length of the text string, use…………… Select one:
Round function
Count function
Sum function
LEN function
Excel offers different predefined margins. Select one:
True
False
To complete a series, use the …………… Select one:
autofill tool
Ctrl
Alt+shift
immediate tool
…………… refers to symbolic link Workbook. Select one:
*.SLW
*.txt
*.prn
*SYLK
The error displayed when a value is not the expected type at the formula is ………… Select one:
#DIV/0!
#VALUE!
#REF!
#RUN!
The error displayed when a formula tries to divide number by 0 is ………… Select one:
#DIV/0!
#VALUE!
#REF!
#RUN!
The filter command is in the …………… tab. Select one:
Search
file
layout
Data
To change the page orientation, Select view tab. Select one:
True
False
When you remove sheet from tab Select…………… Select one:
Delete
Remove
Chart must have headlines. Select one:
True
False
Can delete sheet from workbook. Select one:
True
False
These are Excel extension except………….. Select one:
xls
Dif
DIFT
prn
You can adjacent marigin column from custom marigin. Select one:
True
False
To adjust margins click custom margins. Select one:
True
False
The cell is identified by column number and row header. Select one:
True
False
Error ………… means that the syntax of the formula should be corrected. Select one:
#NAME
#DIV/0!
#VALUE!
#REF!
To move one cell right press………… Select one:
TAB
Shift + TAB
ALT + TAB
Average function is used for summation. Select one:
True
False
You can hide worksheets from workbook. Select one:
True
False
Min value use mean function. Select one:
True
False
You can change the colour of cell using conditional formatting. Select one:
True
False
To delete object in Excel sheet….. Select one:
Select it and then press the Delete key
Press Backspace without selecting the object
Right‑click the object and choose Format Cells
Use AutoSum to clear the object
The spreadsheet is used for the organization and the storage of data in tabular form. Select one.
True
False
To insert a column, right‑click on the column letter that is after the column you want to insert. Select one.
True
False
The Autofill tool mouse pointer at the bottom‑left center of the cell appears as what shape? Select one.
Plus sign (+)
Crosshair
Arrow pointer
Hand icon
To select a range, select a cell then, with the left mouse button pressed, drag over the other cells. Select one.
True
False
When all the numbers between 1000 and 2000 in a range should be displayed in green, you can use which feature? Select one.
Conditional formatting
IF function
To write data on a new line within the same cell, enter a line break by pressing ALT + Enter. Select one.
True
False
How can you reach a cell in a quick way? Select one.
Write the cell name in the Name box
Scroll to the cell with the mouse
Open Find and replace
Change the worksheet zoom level
The worksheet tab color can't be changed. Select one.
True
False
The Autofill tool is used only to copy content, increment, or complete a series. Select one.
True
False
To move a chart to a new sheet or another file, use the Move Chart option on which tab? Select one.
Chart Design tab
View tab
Insert tab
Home tab
You can see the cell content at the: Select one.
Formula bar
Title bar
Protection tab changes the alignment of the data within a cell. Select one.
True
False
To select non‑adjacent rows or columns, hold Control and select the row or column numbers/letters. Select one.
True
False
Name box is a bar that appears at the left corner of the formula bar and usually includes the name of the active cell. Select one.
True
False
Excel displays the error #DIV/0! when a formula tries to divide a number by 100. Select one.
True
False
To color a worksheet tab, which action should you use? Select one.
Right‑click the worksheet name, choose Tab Color, select a color
Use Conditional formatting
Change the Status bar color
Open Page Layout and set Theme Colors
Which element consists of tab groups and commands? Select one.
Ribbon
Status bar
Title bar
Formula bar
Maximize and minimize are considered what? Select one.
Control buttons
Command tabs
Toolbar items
Status indicators
Press which key to move one cell to the right? Select one.
Tab
Enter
Spacebar
Right Arrow
When we open a new workbook, Excel gives it a default name. Select one.
True
False
You can move a chart to a new sheet or another file using the Move Chart option from the View tab. Select one.
True
False
Conditional formatting allows automatic application of colors on one or more cells based on the cell value. Select one.
True
False
Spreadsheet is a powerful analysis tool for large amounts of data. Select one.
True
False
To temporarily hide rows that we do not want to display, we can use which feature? Select one.
Data filtering
Conditional formatting
Data sorting
Freeze panes
You can hide the headings of the Excel sheet when printing. Select one.
True
False
You can select an entire column by selecting the column number. Select one.
True
False
A bar located at the bottom of the program window is called what? Select one.
Status bar
Title bar
Menu bar
Formula bar
Which interface element contains three options (Save, Undo, and Redo) by default? Select one.
Quick Access Toolbar
Status bar
Ribbon
Formula bar
Press Delete on the keyboard to delete values from cells. Select one.
True
False
The SUM function is used to get values summation. Select one.
True
False
What is the total of values divided by the number of values? Select one.
Average
Sum
