Computerised Accounting

17 Questions | By TRUST | Updated: Jan 25, 2013 | Attempts: 160

Questions

Settings

Create your own Quiz

Questions and Answers

1.

A ________________ consists of a grid made from columns and rows?

Correct Answer
Cell Labels Spreadsheet Formulas
2.

What is not a basic part of a spreadsheet?
- A.
  
  Formula
- B.
  
  Cell
- C.
  
  Row
- D.
  
  Column
Correct Answer
A. Formula
3.

Which of the following data can be put inside a cell?
- A.
  
  Row
- B.
  
  Column
- C.
  
  Constant
Correct Answer
C. Constant
4.

In a spreadsheet, the ________ is defined as the horizontal space that is going across the window.

Correct Answer
formula bar, column, row
5.

In a spreadsheet, the __________ is defined as the vertical space that is going across the window.

Correct Answer
column, row, name box
6.

_____________ are used to designate each column's location

Correct Answer
auto fit
7.

___________ are used to designate each row's location

Correct Answer
auto fit,mouse,
8.

In a spreadsheet, the ___________ is defined as the space where a specified row and column intersect.

Correct Answer
active cell,name box,formula bar
9.

True or False: Labels do not have a value associated with them
- A.
  
  True
- B.
  
  False
Correct Answer
A. True
10.

Q.10) True or False: Constants are entries that do not have a specified value
- A.
  
  True
- B.
  
  False
Correct Answer
B. False
11.

All formulas must begin with what?

Correct Answer
=,-,+,>,<
12.

____________ are entries that have equations that calculates the value to display.
- A.
  
  Labels
- B.
  
  Constants
- C.
  
  Spreadsheet
- D.
  
  Formulas
Correct Answer
D. Formulas
13.

Provide the formula for the following spreadsheet: If you work for 23 hours and make $5.36 an hour, how much do you make?
14.

The ___________ function takes all of the values in each of the specified cells and totals their values

Correct Answer
sum, average
15.

The _________ function adds all of the indicated cells together and divides by the total number of cells.

Correct Answer
Average, sum,maximum,minimum
16.

The two most widely used charts are the

Correct Answer
pie chart, bar charts
17.

The ___________ function takes all of the values in each of the specified cells and totals their values

Correct Answer
sum, average

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Jan 25, 2013

Quiz Edited by
ProProfs Editorial Team
May 27, 2011

Quiz Created by
TRUST

Computerised Accounting

A ________________ consists of a grid made from columns and rows?

What is not a basic part of a spreadsheet?

Which of the following data can be put inside a cell?

In a spreadsheet, the ________ is defined as the horizontal space that is going across the window.

In a spreadsheet, the __________ is defined as the vertical space that is going across the window.

_____________ are used to designate each column's location

___________ are used to designate each row's location

In a spreadsheet, the ___________ is defined as the space where a specified row and column intersect.

True or False: Labels do not have a value associated with them

Q.10) True or False: Constants are entries that do not have a specified value

All formulas must begin with what?

____________ are entries that have equations that calculates the value to display.

Provide the formula for the following spreadsheet: If you work for 23 hours and make $5.36 an hour, how much do you make?

The ___________ function takes all of the values in each of the specified cells and totals their values

The _________ function adds all of the indicated cells together and divides by the total number of cells.

The two most widely used charts are the

The ___________ function takes all of the values in each of the specified cells and totals their values