

Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
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
1 / 3
This page cannot be seen from the preview
Don't miss anything!
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