Microsoft Excel Practice Quiz 2

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

212

Subject

Computer Science

Date

Nov 24, 2024

Type

docx

Pages

17

Uploaded by KidCaribouPerson358

Report
96 % Microsoft Excel Practice Quiz 2 96 % Question 1 5 / 5 points When you type data into a spreadsheet, it appears in   the Name box.   the Status bar.   the active cell.   cell Z80. Hide question 1 feedback Correct Typed data appears in the selected cell, also called the active cell. Question 2 5 / 5 points Which of the following statements is  true  of a pie chart?
  It uses vertical bars sized relative to the values in the data series.   It uses horizontal bars sized relative to the values in the data series.   It connects data values with lines.   It displays data as a percentage of a whole. Hide question 2 feedback Correct A pie chart uses slices that are sized as a percentage of a whole. Question 3 5 / 5 points Conditional cell formatting is used to   display more decimal places for a number.   create additional cells in the selected range.   display a color or style format based on a value.   apply formats only when a cell contains text. Hide question 3 feedback
Correct Conditional formats are used to apply a color or other format based on the value in the cell. Question 4 5 / 5 points B10 is an example of a _______ name.   worksheet tab    row    cell    column  Hide question 4 feedback Correct A cell is identified by the location of its column and row, such as "B10." Question 5 5 / 5 points In Excel, adding ________ to shapes, pictures, charts, or other graphics helps people with visual impairments understand pictures and other graphical content through a screen reader.   formatted text
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
  alternative text (alt text)   bold text   caption text Hide question 5 feedback Correct Alternative text (alt text) helps people with visual impairments understand pictures and other graphical content. Question 6 5 / 5 points The default file format for Excel workbook files is the XLSX format. What's another file format that can be used for Excel files?    WQ1   PDF   WKS   XLC Hide question 6 feedback Correct
You can save an Excel workbook as a PDF file as well as XLS. Question 7 5 / 5 points The  Tab  key moves the active cell to the   next cell in the column.   last cell in a row.   last cell in the worksheet.   next cell in the row. Hide question 7 feedback Correct The  Tab  key is used to enter data across a row of cells. Question 8 5 / 5 points One way to move a cell to another location is with the   Cut  and  Paste  commands.   Replace  command.
  Page Layout  tab.   Copy  and  Paste  commands. Hide question 8 feedback Correct The  Cut  command removes a cell’s contents and the  Paste  command inserts the cut data. Question 9 5 / 5 points To sort data in a table, you must   click the arrow button in a column header and then click a  Sort  command.   convert the table to a plain data range before sorting.   retype the data in the order you want it to appear.   select all the data and then click  Sort . Hide question 9 feedback Correct You click the arrow button in a table to display a menu with  Sort  commands.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Question 10 0 / 5 points A relative cell reference   relates to the data it's calculating.   changes relative to the cell it's copied to.   remains constant even when the formula is copied to another cell.   is used to indicate a color format. Hide question 10 feedback Incorrect A relative cell reference changes based on the location of column and row it has been copied to. Question 11 5 / 5 points A table that automatically analyzes and summarizes your data is called a/an   Sparkline.
  PivotTable.   sheet.   Analysis Table. Hide question 11 feedback Correct A PivotTable automatically analyzes and summarizes data. Question 12 5 / 5 points Which of the following statements is  true of a function?   It requires a single cell reference and then changes its format.   It can’t be used in a formula.   It adds a graphic to a worksheet.   It performs a calculation and returns a single value. Hide question 12 feedback Correct
A function uses one or more arguments to make a calculation and return a single value. Question 13 5 / 5 points A filter is used to   create a table.   perform an advanced search with multiple criteria.   sort a table.   hide a select column. Hide question 13 feedback Correct A filter is an advanced form of search and allows multiple criteria for performing a search. Question 14 5 / 5 points Which is an example of an absolute cell reference?   B$2   B2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
  $B$2   $B2 Hide question 14 feedback Correct An absolute cell reference requires dollar signs in front of both the column letter and row number. Question 15 5 / 5 points How can the  Quick Analysis  button be used to format cells?   It can be used to apply dollar signs to numeric data.   It can’t. It’s used to calculate values only.   It can be used to apply conditional formatting to a range.   It can be used to change the font of a cell. Hide question 15 feedback Correct The  Quick Analysis  button has a command for applying conditional formatting.
Question 16 5 / 5 points To add a data series to a chart from the Chart Tools contextual tab, do which of the following steps?     Design Tab > Change Chart Type   Design Tab > Data Group > Switch Row/Column   Select Data > Data Group > Switch Row/Column   Design Tab > Data Group > Select Data Hide question 16 feedback Correct The  Design Tab >   Data Group > Select Data  options are used to add a data series to a chart. Question 17 5 / 5 points Which is the  first  step to applying cell formats?   Select the cell to be formatted.   Right-click the cell and then click  Insert .
  Click in the Name box.   Click a command on the  Page Layout  tab. Hide question 17 feedback Correct The first thing you must do to apply cell formats is select the cell to be formatted. Question 18 5 / 5 points On the Excel Ribbon, select the  Data  tab in the  Sort & Filter  group, and then press the  Sort  button to conduct a/an _______ sort.   table range   PivotTable   multiple column   AutoSum Hide question 18 feedback Correct To conduct a multiple column sort, you select the data tab in the Sort & Filter group and then click the  Sort  button.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Question 19 5 / 5 points What function is used to show returns of the first character or characters in a text string based on the number of characters specified?   TEXTJOIN   RIGHT   CONCAT   LOWER Hide question 19 feedback Correct The RIGHT function shows the returns of the first character or characters in a text string. Question 20 5 / 5 points Data in chronological order is sorted   in order from highest to lowest.   in order from lowest to highest.   in descending order.
  in alphabetical order. Hide question 20 feedback Correct Data in chronological order is arranged from lowest to highest. Question 21 5 / 5 points You’ve created a spreadsheet for your daily appointments, but you accidently left out the Thursday column. Which is the fastest way to correct the worksheet?   Delete the Friday through Sunday columns and then add the Thursday column and retype the Friday, Saturday, and Sunday columns beside it.   Right-click the Friday column letter and then click  Insert  to create a column for Thursday.   Add the Thursday column after Sunday and then move it.   Close the file without saving and start over. Hide question 21 feedback Correct To add a missing column, you should insert one between existing ones.
Question 22 5 / 5 points The IF function is used to   count the number of values in a range.   return a value based on a comparison.   sum a range.   average a range. Hide question 22 feedback Correct The IF function makes a comparison and then returns a result based on that comparison. Question 23 5 / 5 points What is the result of the formula =5+2*3+1?   #DIV/0   28   12
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
  22 Hide question 23 feedback Correct The result is 12 because the order of operations states that multiplication is performed first and then the addition and subtraction. Question 24 5 / 5 points A chart legend   is based on the category labels in the first column of data.   provides the boundaries of the chart graphic.   corresponds to the title of the data series column.   is used to change the style of a chart. Hide question 24 feedback Correct A chart legend corresponds to the category labels in the first column of data. Question 25 5 / 5 points Labels are used in a worksheet to
  describe data in a row or column.   name the workbook.   create a time entry.   make a calculation. Hide question 25 feedback Correct Labels are text that identify the contents of columns and rows.

Related Documents

q3.pptx
ModuleSevenLessonSixActivity.ipynb - Colaboratory.pdf
63A5D2A1-FDAA-45C1-B81F-BF4211467948
Assignment 7 Unchanged.docx
Screenshot (563).png
I think we can make the choice of Machine learning.docx
Long Quiz 002 - (29).png
Keren Iyolo extar credit 172.docx
L04 Check Your Understanding 3: [23FA] CAS 100A, Sec 02: Eff Speech (WC, Bedell).pdf
5.docx
CyberArk Sentry PAM-SEN Practice Test Questions.pdf
Self-Quiz Unit 8_ Attempt review.pdf
Recommended textbooks for you
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
SEE MORE TEXTBOOKS