Microsoft Excel Pretest

Ranitha Jeyasing
Quiz by Ranitha Jeyasing, updated more than 1 year ago
Ranitha Jeyasing
Created by Ranitha Jeyasing over 6 years ago
569
0

Description

To assess Excel Skills

Resource summary

Question 1

Question
What is the purpose of a pivot table?
Answer
  • To compare data from different workbooks.
  • To merge different scenarios.
  • To summarize data in a three dimensional table.
  • To highlight formula errors.
  • To perform a what-if analysis on a data table.

Question 2

Question
If I fill out the PivotTable Field list as below to create a pivot table, what will be the result? SalesPerson then Region to Row Field, Sales to Value Field, Month to Report Filter (Accept Default Options)

Question 3

Question
In this column chart, the columns are represented by images. What method can be used to insert images in place of traditional columns in such a chart?
Answer
  • I cannot do this with Excel, but I can import my chart into PowerPoint, edit it, and reinsert it into Excel.
  • This is not really a chart, but an image composed of shapes and drawings.
  • I copy an image to the clipboard, select the columns of the chart by clicking on them, and then paste the image.
  • I select the chart, then select a chart type from the Chart Styles gallery .

Question 4

Question
I entered a date in cell B4 that I wish to replace with the value 10.5 (to be used in calculations) and have it display as “10.5” (without the quotes). How can I do this?
Answer
  • I can only enter a date in cell B4, not any other type of value.
  • First I should delete the date with the DELETE key.
  • I should change the number formatting of the cell.
  • I should type a space before entering the value 10.5.
  • I simply enter 10.5 in the cell and the value will display correctly.

Question 5

Question
Which chart type is best for comparing the product quality test scores?
Answer
  • A doughnut chart
  • A radar chart
  • A bar chart
  • A line chart
Show full summary Hide full summary

Similar

Grade 5 Review
Yolande Samuels-Cole
Microsoft Excel
Nikol Garcia
MICROSOFT EXCEL Y SUS PRINCIPALES HERRAMIENTAS
RONALDO VITOLA CANTILLO
MICROSOFT EXCEL Y SUS PRINCIPALES HERRAMIENTAS
RONALDO VITOLA CANTILLO
Microsoft Excel todas sus herramientas
FARID ALLEN ABDALA FERNANDEZ
Microsoft Excel y sus principales herramientas
Leidy Laura Solano Oquendo
MICROSOFT EXCEL Y SUS PRINCIPALES HERRAMIENTAS
Leidy Laura Solano Oquendo
Microsoft Excel
Sofia Sá
Microsoft Excel y sus principales herramientas
DAYANNA LUCIA CORONADO PATIÑO
Microsoft Excel y sus principales herramientas
DAYANNA LUCIA CORONADO PATIÑO
AQA GCSE Physics Unit 2.2
Matthew T