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

Spreadsheet Essentials Test: Morgan Community College Study Guide, Exams of Agricultural engineering

A study guide for a test on spreadsheet essentials from morgan community college's ag and business management. The guide includes multiple-choice, true/false, fill-in-the-blank, and matching questions to assess the learner's knowledge of spreadsheets.

Typology: Exams

Pre 2010

Uploaded on 08/18/2009

koofers-user-a8r-1
koofers-user-a8r-1 🇺🇸

10 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Morgan Community College – Ag and Business Management 08/14/04
File:Study Guide - Spreadsheets.doc Page 7
Test your Knowledge
Spreadsheet Essentials
Test Your Knowledge
Name _____________________________________________
Date__________________________
Instructions: This test will help you determine what you know about spreadsheets.
Underlined items indicate the content of a spreadsheet cell. Follow the instructions for
each of the sections below. This assessment extends to a second page. Good luck.
Multiple-Choice: Read the statement and select the best answer by placing the letter
beside the answer in the blank space provided. Each question is worth 10 points.
1) ____ In a spreadsheet cell a number such as 3.1416 is considered to be a/an:
a) range
b) formula
c) label
d) value
e) None of the above
2) ____ If a spreadsheet cell contained =(72-27)*2 what number would the cell display?
a) 36
b) 18
c) 90
d) 3888
e) None of the above
True/False: Indicate whether the statement is true or false by placing a T or F in the
space by the statement. Each question is worth 10 points.
3) ____ Clicking on Format => Cells => Border allows the user to change the
background color of the spreadsheet cell.
4) ____ The formula =C$35*$A5G is a valid formula (in other words, it will NOT
result in an error message).
pf2

Partial preview of the text

Download Spreadsheet Essentials Test: Morgan Community College Study Guide and more Exams Agricultural engineering in PDF only on Docsity!

Morgan Community College – Ag and Business Management 08/14/

File:Study Guide - Spreadsheets.doc Page 7

Test your Knowledge Spreadsheet Essentials Test Your Knowledge

Name _____________________________________________ Date__________________________

Instructions: This test will help you determine what you know about spreadsheets. Underlined items indicate the content of a spreadsheet cell. Follow the instructions for each of the sections below. This assessment extends to a second page. Good luck. Multiple-Choice: Read the statement and select the best answer by placing the letter beside the answer in the blank space provided. Each question is worth 10 points.

  1. ____ In a spreadsheet cell a number such as 3.1416 is considered to be a/an: a) range b) formula c) label d) value e) None of the above

  2. ____ If a spreadsheet cell contained =(72-27)*2 what number would the cell display? a) 36 b) 18 c) 90 d) 3888 e) None of the above

True/False: Indicate whether the statement is true or false by placing a T or F in the space by the statement. Each question is worth 10 points.

  1. ____ Clicking on Format => Cells => Border allows the user to change the background color of the spreadsheet cell.
  2. ____ The formula =C$35*$A5G is a valid formula (in other words, it will NOT result in an error message).

Morgan Community College – Ag and Business Management 08/14/

File:Study Guide - Spreadsheets.doc Page 8

Fill-in-the-blank: Read the statement and write in the missing word. Each question is worth 10 points.

  1. The ________________ command is used to duplicate the contents of one cell or range once or many times.
  2. The intersection of one row and one column in a spreadsheet is called a __________________.

Matching: Below are two columns. One column has a statement and the second column has possible answers to the statement. Select the letter of the item in the second column that best fits the statement in the first column, and write the letter in the space provided. You will only use four of the 10 possible answers; none of the answers will be repeated. Each question is worth 10 points.

  1. ____ The toolbar with the common commands such as File =>, Edit =>, etc.
  2. ____ Command used to change the name of a file.
  3. ____ Contents of a spreadsheet cell that begins with a = character.
  4. ____ The command to move the contents of one or more cells to the clipboard.

a) formula b) value c) copy d) cut e) status bar f) menu bar g) title bar h) File => Save i) File => Save As j) File => Exit