Question: Note: Answer the following questions be selecting the right option: 1. The function that lets you add up a range of cells or values is;

Note: Answer the following questions be selecting the right option:

1. The function that lets you add up a range of cells or values is;

  1. AVERAGE
  2. SUM
  3. MIN
  4. MAX

2. Microsoft Excel is categorized as ?

  1. Presentation Software
  2. Spreadsheet Software
  3. Database Software
  4. Word Processing Software

3. What is normally used to perform calculations in a spreadsheet?

  1. Variable
  2. Formula
  3. Conditional Formatting
  4. Macro

4 . A visual representation of worksheet data is known as;

  1. Column
  2. Data
  3. Chart
  4. Legend

5. Which of the following option describes what is charted and can be placed above or below the chart?

  1. Chart Title
  2. Chart Area
  3. Bar chart
  4. Pie Chart

6. What is the first thing you have to do in a spreadsheet before you can create a chart/graph?

  1. Click insert charts/graphs
  2. Go to file, print
  3. Highlight the data with your mouse
  4. Bold all the information

7. Data graphed as slices of a circular area is called;

  1. Bar Chart
  2. Scatter Plot
  3. Pie Chart
  4. Column Chart

8. AutoSum refers to:

  1. Adds the values in a function or set of cells
  2. Provides the middle number of the range of numbers used
  3. A combination of numbers and symbols used to express a calculation.
  4. To copy a cells contents and formatting into other cells

9. The function COUNT is specific for;

  1. Counting Cells
  2. Counting Text
  3. Counting Number
  4. Counting Tables

10. What function is used to find the lowest data ?

  1. AVERAGE
  2. MIN
  3. MAX
  4. SUM

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!