# Excel Test - Fall 2015

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Christy Williams
C
Christy Williams
Community Contributor
Quizzes Created: 13 | Total Attempts: 3,867
Questions: 38 | Attempts: 183

Settings

• 1.

### The cell into which you are currently entering data; it has a heavy border around it

• A.

Name box

• B.

Cell

• C.

Active cell

• D.

Gridlines

C. Active cell
Explanation
The active cell refers to the cell in which the user is currently entering data. It is indicated by a heavy border around it. This allows the user to easily identify the cell they are working on and ensures that any data they input is entered into the correct cell.

Rate this question:

• 2.

### The small green square located in the lower right corner of the active cell

• A.

Option handle

• B.

Autofill

• C.

Status bar

• D.

Range

B. Autofill
Explanation
The small green square located in the lower right corner of the active cell is called Autofill. Autofill is a feature in spreadsheet programs that allows users to quickly fill a series of cells with a pattern or sequence of data. By dragging the autofill handle, users can easily copy and fill the contents of a cell or a range of cells with the desired data.

Rate this question:

• 3.

### The ________________ allows you to add all the numbers in a range of cells.

• A.

MIN function

• B.

SUM function

• C.

MAX function

• D.

B. SUM function
Explanation
The SUM function in Excel allows you to add all the numbers in a range of cells. It is a mathematical function that provides the sum of a given set of numbers. By using the SUM function, you can easily calculate the total of multiple cells without having to manually add them one by one. This function is commonly used in financial analysis, budgeting, and data analysis tasks.

Rate this question:

• 4.

• A.

• B.

Office Button

• C.

• D.

Name Box

Explanation
The Quick Access Toolbar provides easy access to frequently used commands in a software application. It is a customizable toolbar that allows users to add their most commonly used commands for quick access, eliminating the need to navigate through various menus and options. This toolbar is typically located at the top of the application window, providing a convenient and efficient way for users to perform common tasks without having to search for specific commands.

Rate this question:

• 5.

### Excel opens a new workbook with ________ worksheet(s).

• A.

One

• B.

Two

• C.

Three

• D.

Five

A. One
Explanation
When Excel opens a new workbook, it automatically creates one worksheet. This is the default setting in Excel, and it allows users to start entering and organizing data immediately. However, users can add more worksheets to the workbook if needed, by clicking on the "+" button next to the existing worksheet tabs.

Rate this question:

• 6.

### The numbers on the left side of the grid are

• A.

• B.

• C.

• D.

Footers

Explanation
The numbers on the left side of the grid are referred to as row headings. These numbers are used to identify and label each row in the grid. They help in organizing and categorizing the data in the grid by providing a unique identifier for each row.

Rate this question:

• 7.

### The Name Box displays the active cell reference.

• A.

True

• B.

False

A. True
Explanation
The Name Box is a feature in Microsoft Excel that displays the active cell reference, which is the address of the cell that is currently selected or being edited. This allows users to easily identify and keep track of the cell they are working on. Therefore, the statement "The Name Box displays the active cell reference" is true.

Rate this question:

• 8.

### How are columns designated in Excel?

• A.

Letters

• B.

Numbers

• C.

Triangles

• D.

Combination of letters and numbers

A. Letters
Explanation
Columns in Excel are designated using letters. Each column is identified by a letter, starting from "A" for the first column, "B" for the second column, and so on. This letter designation makes it easier to reference and work with specific columns in Excel formulas, functions, and data manipulation tasks.

Rate this question:

• 9.

### This means the cell's content is positioned at the far left in the cell

• A.

Justified

• B.

Right-aligned

• C.

Center-aligned

• D.

Left-aligned

D. Left-aligned
Explanation
The correct answer is left-aligned because when content is left-aligned in a cell, it is positioned at the far left. This means that the content starts from the left edge of the cell and extends towards the right.

Rate this question:

• 10.

### The basic unit of a worksheet into which you enter data is called a __________________.

• A.

Cell

• B.

Box

• C.

Range

• D.

Gridline

A. Cell
Explanation
A cell is the basic unit of a worksheet where you can enter data. It is a rectangular box that is formed by the intersection of a row and a column in a grid-like structure. Each cell can hold a single piece of data, such as a number, text, or formula. Cells allow you to organize and manipulate data in a spreadsheet, making it easy to perform calculations and analysis.

Rate this question:

• 11.

### When you enter text or numbers into a cell, it appears in the cell as well as in the formula toolbar

• A.

True

• B.

False

A. True
Explanation
When you enter text or numbers into a cell, it appears in the cell as well as in the formula toolbar. This is true because the formula toolbar displays the content of the active cell, allowing users to view and edit the cell's contents directly from the toolbar. As a result, any text or numbers entered into a cell will be visible both in the cell itself and in the formula toolbar.

Rate this question:

• 12.

### You can select an entire row by pressing Ctrl + spacebar

• A.

True

• B.

False

B. False
Explanation
You cannot select an entire row by pressing Ctrl + spacebar. This keyboard shortcut is used to select an entire column, not a row.

Rate this question:

• 13.

### This indicates the beginning of a formula

• A.

/

• B.

\

• C.

+

• D.

=

D. =
Explanation
The given symbols ("/", "\", "+", "=") are commonly used in mathematical formulas. In this case, the "=" symbol indicates the beginning of a formula, where the left side of the equal sign represents the expression or equation that needs to be solved or evaluated. Therefore, the correct answer is "=" as it signifies the start of a mathematical formula.

Rate this question:

• 14.

### This indicates the lowest value in a range of cells

• A.

MAX

• B.

MIN

• C.

AVG

• D.

SUM

B. MIN
Explanation
The MIN function is used to find the lowest value in a range of cells. In this case, the question is asking for the function that indicates the lowest value. Therefore, the correct answer is MIN.

Rate this question:

• 15.

### Adds all values in a range of cells

• A.

MAX

• B.

MIN

• C.

AVG

• D.

SUM

D. SUM
Explanation
The SUM function in Excel is used to add up all the values in a specified range of cells. It calculates the total sum of the numbers in the range and returns the result. This function is commonly used when you need to find the total of a set of numbers or add up a column or row of values. Therefore, the correct answer for this question is SUM.

Rate this question:

• 16.

### Opens an existing file or workbook

• A.

Ctrl O

• B.

Ctrl N

• C.

Crtl R

• D.

Ctrl P

A. Ctrl O
Explanation
Ctrl O is the correct answer because it is the keyboard shortcut that is commonly used to open an existing file or workbook. By pressing Ctrl O, the user can quickly access and open a file or workbook without having to go through the traditional method of navigating through menus and selecting the "Open" option. This shortcut is widely recognized and used in various software applications, including word processors, spreadsheets, and graphic design programs.

Rate this question:

• 17.

### Creates a new workbook in Excel

• A.

Ctrl O

• B.

Ctrl N

• C.

Ctrl P

• D.

Ctrl E

B. Ctrl N
Explanation
Ctrl N is the keyboard shortcut for creating a new workbook in Excel. When this shortcut is used, a new blank workbook is opened, allowing the user to start entering data or creating new spreadsheets. This shortcut is commonly used when the user wants to create a new file or start a new project in Excel without having to go through the menu options.

Rate this question:

• 18.

### Saves a workbook

• A.

Ctrl O

• B.

Ctrl S

• C.

Ctrl W

• D.

Ctrl K

B. Ctrl S
Explanation
Ctrl S is the correct answer because it is the keyboard shortcut for saving a workbook. When you press Ctrl S, it triggers the save function in most software applications, including spreadsheet programs like Microsoft Excel. This shortcut allows you to quickly save your work without having to navigate through menus or use the mouse. By pressing Ctrl S regularly, you can ensure that your progress is saved and prevent any potential loss of data in case of a computer crash or power outage.

Rate this question:

• 19.

### Closes a workbook in Excel

• A.

Ctrl U

• B.

Ctrl E

• C.

Ctrl W

• D.

Ctrl Z

C. Ctrl W
Explanation
Ctrl W is the correct answer because it is the keyboard shortcut in Excel that closes a workbook. Ctrl U is the shortcut for underlining text, Ctrl E is the shortcut for centering text, and Ctrl Z is the shortcut for undoing the last action. Therefore, the only option that specifically pertains to closing a workbook is Ctrl W.

Rate this question:

• 20.

### Which key do you press if you need help with something in Excel?

• A.

F1

• B.

F2

• C.

F3

• D.

F4

A. F1
Explanation
Pressing the F1 key in Excel opens the Help window, which provides assistance and information on various features and functions in Excel. This key is commonly used to access the help menu and find solutions to any issues or questions that may arise while using Excel.

Rate this question:

• 21.

### Which key do you press if you want to run spell check?

• A.

F4

• B.

F5

• C.

F6

• D.

F7

D. F7
Explanation
Pressing the F7 key initiates the spell check function in many applications, including Microsoft Word. This key is commonly used to check for spelling and grammar errors in a document. By pressing F7, the software will scan the text and highlight any potential mistakes, allowing the user to review and correct them.

Rate this question:

• 22.

### To move to the next cell on the right you can...

• A.

Press Tab

• B.

Use the directional right arrow

• C.

Press Enter

• D.

You press Tab or use the directional right arrow

D. You press Tab or use the directional right arrow
Explanation
To move to the next cell on the right, you can either press the Tab key or use the directional right arrow. Both of these actions will navigate the cursor to the adjacent cell on the right side.

Rate this question:

• 23.

### Use this keyboard shortcut to move to cell A1 regardless of where you are on the spreadsheet.

• A.

Ctrl Home

• B.

Ctrl End

• C.

Ctrl F7

• D.

Ctrl O

A. Ctrl Home
Explanation
Ctrl Home is the correct answer because it is a keyboard shortcut that allows the user to quickly navigate to cell A1 on the spreadsheet, regardless of their current location. This shortcut is useful when working with large spreadsheets or when the user wants to quickly return to the beginning of the sheet.

Rate this question:

• 24.

### To preview and print a workbook you use

• A.

Ctrl H

• B.

Ctrl P

• C.

Ctrl U

• D.

Ctrl B

B. Ctrl P
Explanation
To preview and print a workbook, you use Ctrl P. This keyboard shortcut is commonly used in various applications to open the print dialog box, allowing you to review the document before printing it. By pressing Ctrl P, you can easily access the print settings, such as selecting the printer, adjusting the page layout, and choosing the number of copies to print. This shortcut is widely known and used in many software programs, including Microsoft Excel for printing workbooks.

Rate this question:

• 25.

### To undo a command you can click Undo on the Quick Access Toolbar or press

• A.

Ctrl I

• B.

Ctrl X

• C.

Ctrl Z

• D.

Ctrl M

C. Ctrl Z
Explanation
Pressing Ctrl Z is the correct answer to undo a command. The Ctrl Z keyboard shortcut is a common and widely used command in many software applications, including Microsoft Office programs. It allows users to reverse their previous action and restore the document or file to its previous state. This shortcut is intuitive and easy to remember, making it a popular choice for undoing actions.

Rate this question:

• 26.

### Cell names are made from their column letter and row number

• A.

True

• B.

False

A. True
Explanation
Cell names in a spreadsheet are indeed made from their column letter and row number. Each cell in a spreadsheet is identified by a unique combination of a letter representing the column and a number representing the row. This naming convention allows users to easily reference and locate specific cells within a spreadsheet. Therefore, the statement "Cell names are made from their column letter and row number" is true.

Rate this question:

• 27.

### To select an entire worksheet you can click the Select All Button in the top left corner of the grid or press Ctrl A.

• A.

True

• B.

False

A. True
Explanation
To select an entire worksheet, you can either click the Select All Button located in the top left corner of the grid or use the keyboard shortcut Ctrl A. This means that by clicking the Select All Button or pressing Ctrl A, you can easily select all the cells in the worksheet at once. Therefore, the statement "True" is correct.

Rate this question:

• 28.

### Press __________ to bold text

• A.

Ctrl P

• B.

Ctrl B

• C.

Ctrl C

• D.

Ctrl D

B. Ctrl B
Explanation
Pressing Ctrl B is the correct answer because it is the keyboard shortcut used to bold text. The other options (Ctrl P, Ctrl C, and Ctrl D) do not have any specific function related to bolding text. Therefore, Ctrl B is the appropriate shortcut to use in order to make text bold.

Rate this question:

• 29.

### To select an entire column you press Ctrl + Spacebar

• A.

True

• B.

False

A. True
Explanation
To select an entire column in a document or spreadsheet, you can use the Ctrl + Spacebar keyboard shortcut. This combination of keys will highlight the entire column where the cursor is located, making it easier to manipulate or format the data within that column. Therefore, the given answer "True" is correct.

Rate this question:

• 30.

### To hide a selected row you can press

• A.

Ctrl 9

• B.

Ctrl 3

• C.

Ctrl U

• D.

Ctrl 6

A. Ctrl 9
Explanation
Pressing Ctrl 9 is the correct answer because it is the keyboard shortcut to hide a selected row in many spreadsheet programs, including Microsoft Excel. This shortcut allows users to quickly hide rows that they do not want to be displayed, providing a way to organize and declutter the spreadsheet.

Rate this question:

• 31.

### To edit a cell's content, you can select the cell and then click the Formula Bar or double-click the cell.

• A.

True

• B.

False

A. True
Explanation
To edit a cell's content, you have two options. The first option is to select the cell and then click on the Formula Bar, which is located at the top of the Excel window. The second option is to double-click the cell itself. Both of these actions will allow you to edit the content of the cell. Therefore, the statement "To edit a cell's content, you can select the cell and then click the Formula Bar or double-click the cell" is true.

Rate this question:

• 32.

### If you have a cell in which you want to copy the formatting you use the

• A.

Cut and Paste

• B.

Tables

• C.

Cell Styling

• D.

Format Painter

D. Format Painter
Explanation
The Format Painter tool allows you to copy the formatting from one cell and apply it to another cell. It is a quick and efficient way to maintain consistency in formatting throughout a spreadsheet. By selecting the cell with the desired formatting and using the Format Painter, you can easily apply the same formatting to other cells without having to manually adjust each cell individually.

Rate this question:

• 33.

### There is basically one way to adjust the column width and row height.

• A.

True

• B.

False

B. False
Explanation
The statement "There is basically one way to adjust the column width and row height" is false. In most spreadsheet software, such as Microsoft Excel or Google Sheets, there are multiple ways to adjust the column width and row height. Users can manually drag the column borders or row borders to adjust the size, use the auto-fit feature to automatically adjust the size based on the content, or specify exact dimensions using the formatting options. Therefore, the given statement is incorrect.

Rate this question:

• 34.

### To rename a worksheet tab you must double-click the sheet tab, enter a new name and press Enter

• A.

True

• B.

False

A. True
Explanation
To rename a worksheet tab, you need to double-click on the sheet tab. This action allows you to enter a new name for the worksheet tab. After entering the new name, you must press the Enter key to apply the changes. This process is necessary to change the name of a worksheet tab in most spreadsheet software programs. Therefore, the statement "True" accurately describes the correct method for renaming a worksheet tab.

Rate this question:

• 35.

### To freeze panes so that you can see headings no matter how far you scroll down, you must click the _______ tab on the Ribbon and click the Freeze Panes Button.

• A.

Page Layout

• B.

View

• C.

Formulas

• D.

Home

B. View
Explanation
To freeze panes so that you can see headings no matter how far you scroll down, you must click the View tab on the Ribbon and click the Freeze Panes Button. This is because the View tab in Microsoft Excel contains various options and settings related to the visual display of the spreadsheet. The Freeze Panes Button is specifically used to freeze certain rows or columns in order to keep them visible while scrolling through large amounts of data.

Rate this question:

• 36.

### Which is the correct formula for adding the contents of cells D8 through G8?

• A.

=AVG(D8:G8)

• B.

=SUM(D8+G8)

• C.

=D8+E8+G8

• D.

=SUM(D8:G8)

D. =SUM(D8:G8)
Explanation
The correct formula for adding the contents of cells D8 through G8 is =SUM(D8:G8). The SUM function in Excel is used to calculate the sum of a range of cells. In this case, it will add the values in cells D8, E8, F8, and G8 together to give the total sum.

Rate this question:

• 37.

### When printing your only option is to print the entire worksheet

• A.

True

• B.

False

B. False
Explanation
The statement is false because when printing, you have the option to print the entire worksheet, a selected range of cells, or specific items such as charts or tables. Therefore, it is not true that your only option is to print the entire worksheet.

Rate this question:

• 38.

### To Adjust page margins, orientation, size and page breaks you click on the _______ tab.

• A.

Home

• B.

Page Layout

• C.

Formulas

• D.

View