Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Microsoft Excel Essential Training: Multiple Choice Questions and Answers, Exams of Accounting

A series of multiple-choice questions and answers covering essential microsoft excel functionalities. it tests knowledge of various features, including formulas, formatting, data manipulation, and chart creation. The questions are suitable for assessing basic to intermediate excel skills, making it a valuable resource for students and professionals alike. The questions cover a range of topics, from basic cell operations to more advanced features like pivottables and macros, providing a comprehensive overview of excel's capabilities.

Typology: Exams

2024/2025

Available from 05/13/2025

EXCELLENTPAPERS
EXCELLENTPAPERS 🇺🇸

3.5

(2)

406 documents

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Excel Essential Training | 100% Correct
Answers | Verified | Latest 2024 Version
In Excel, a file is a ____________. - ✔✔workbook
You click once a cell that has the word "cat" in it and begin typing the word "dog", and then hit Return on
your keyboard. The cell - ✔✔now says "dog"
The most effective way to add up five different cells in a row is to _____ (after typing the equal sign into
the formula bar). - ✔✔use the function SUM, type an open parenthesis, and the highlight the five cells
What is true of formatting cells to a particular category, such as Accounting or Currency? - ✔✔This
adjusts the display of your data, but not the data itself
When moving or copying data from one cell to another, in order to maintain the formulas of the original
cell you must _____. - ✔✔simply complete the action. Excel maintains the formulas for you
Which of the following is not type of Sparkline (mini chart)? - ✔✔Scatter
_____ means "exact match" when creating a VLOOKUP. - ✔✔FALSE
If you highlight a column and then click the Sort alphabetically button (A-Z), - ✔✔only the data in the
column is sorted
All of the following are required to begin creating a PivotTable, except: _____. - ✔✔Begin with an equal
sign and open parenthesis
A macro is a way to automate a sequence of steps in your work. - ✔✔true
Excel is _____. - ✔✔all of these answers
pf3

Partial preview of the text

Download Microsoft Excel Essential Training: Multiple Choice Questions and Answers and more Exams Accounting in PDF only on Docsity!

Excel Essential Training | 100% Correct

Answers | Verified | Latest 2024 Version

In Excel, a file is a ____________. - ✔✔workbook You click once a cell that has the word "cat" in it and begin typing the word "dog", and then hit Return on your keyboard. The cell - ✔✔now says "dog" The most effective way to add up five different cells in a row is to _____ (after typing the equal sign into the formula bar). - ✔✔use the function SUM, type an open parenthesis, and the highlight the five cells What is true of formatting cells to a particular category, such as Accounting or Currency? - ✔✔This adjusts the display of your data, but not the data itself When moving or copying data from one cell to another, in order to maintain the formulas of the original cell you must _____. - ✔✔simply complete the action. Excel maintains the formulas for you Which of the following is not type of Sparkline (mini chart)? - ✔✔Scatter _____ means "exact match" when creating a VLOOKUP. - ✔✔FALSE If you highlight a column and then click the Sort alphabetically button (A-Z), - ✔✔only the data in the column is sorted All of the following are required to begin creating a PivotTable, except: _____. - ✔✔Begin with an equal sign and open parenthesis A macro is a way to automate a sequence of steps in your work. - ✔✔true Excel is _____. - ✔✔all of these answers

You highlight a column of data in a worksheet. In the status bar below, you'll see all of the following by default, except: _____. - ✔✔Minimum and Maximum values You can create a new workbook by pressing Ctrl+n on your keyboard, or for a greater variety of options, - ✔✔navigating to File > New Date entries are numbers and, by default, - ✔✔lined up on the right side of the cell Save is a safer way to save your work than Save As. - ✔✔False When you copy a formula into an adjacent cell, Excel will adjust the corresponding columns/rows to fit that cell. - ✔✔true How can you access font styles and effects other than what is presented by default on the Home ribbon tab? - ✔✔click the dialog box launcher in the bottom right-hand corner of the Font section How can you insert a new row into your data without disturbing an adjacent set of data on the same sheet? - ✔✔highlight only the data where you'd like to insert a row. Right-click>Insert...>Shift cells down All of the following are ways to print your spreadsheets with greater efficiency, except: - ✔✔Remove all headers and footers To create a chart, you begin by _____. - ✔✔selecting data Which of the following is not type of Sparkline (mini chart)? - ✔✔Scatter To see multiple worksheets from different files at once, - ✔✔Click on the view tab > Arrange All