How do you display current date and time in MS Excel?


Options: date () B. Today () C. now () D. time ()

Ans:– C ,


Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 7102 | Level: Moderate




Got some suggestion about this question or to make this site better? Please leave your comments below.


Want to see where do you stand among other aspirants in "Computer" Category?

Click Here to take quick 5 mins MCQ test to find out.

More MS-Excel Related questions:


. Which mode loadsminimal set of drivers when starting Windows?
Options: a. Safe Mode b. Normal Mode c. VGA Mode d. Network Support Mode

Ans: a, a


Point out the error in the following program. #include<stdio.h> #include<stdarg.h> int main() { void display(char *s, int num1, int num2, ...); display("Hello", 4, 2, 12.5, 13.5, 14.5, 44.0); return 0; } void display(char *s, int num1, int num2, ...) { double c; char s; va_list ptr; va_start(ptr, s); c = va_arg(ptr, double); printf("%f", c); }
Options: Error: invalid arguments in function display(),    Error: too many parameters,    Error: in va_start(ptr, s);,    No error

Ans:C ,C


Which of the following typically uses a keyboard for input?
Options: desktop terminal,    point-of-sale terminal,    financial transaction terminal,    executive workstation

Ans:E ,E


To exit from the Resume Wizard and return to the document window without creating a resume , click the _____ button in any panel in the Resume Wizard dialog box.
Options: a. Cancel b. Back c. Next d. Finish

Ans:– D,– D


. Insert Date, Format Page Number, and Insert AutoText are buttons on the _____ toolbar.
Options: a. Formatting b. Header and Footer c. Standard d. Edit

Ans:– B,– B


What problem is solved by Dijkstra's banker's algorithm?
Options: mutual exclusion,    deadlock recovery,    deadlock avoidance,    cache coherence

Ans:C ,C


Which is a non-standard version of a computing language?
Options: PROLOG,    APL,    Army,    PL/1

Ans:C,(Canswer


_____ decisions are those decisions for which policy standards or guidelines are already established.
Options: programmable,    control,    predictive reports,    relevant

Ans:A ,A


A typical worksheet has …. Number of columns
Options: a. 128 b. 256 c. 512 d. 1024

Ans:#8211; b,#8211; b


. The central processing unit (CPU) consists of
Options: A) Input, output and processing B) Control unit, primary storage, and secondary storage C) Control unit, arithmetic-logic unit and primary storage D) Control unit, processing, and primary storage

Ans:C,C


A temporary storage area, attached to the CPU, for I/O operations is a:
Options: chip,    buffer,    register,    core

Ans:B ,B


In the instruction, 500 SUBA # 50 the command field is:
Options: 500,    # 50000,    SUBA,    (b) and (c)

Ans:C ,C


A Microsoft Windows is .....a(n)
Options: a. Operating system b. Graphic program c. Word Processing d. Database program

Ans:a,a


What can he used to set up a firewall on a Linux system?
Options: netstat,    route,    trace,    ipchains

Ans:D ,D


. If you will be displaying or printing your document on another computer, you’ll want to make sure and select the _____________ option under the ‘Save’ tab.
Options: a. Embed Fonts b. Embed True Type Fonts c. Save True Type Fonts d. Save Fonts

Ans:– B,– B


Assuming 100% efficiency, what is the power being consumed at the secondary winding of the transformer described in question 91?
Options: 200 W,    1000 W,    20 W,    100 W

Ans:A ,A


Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
Options: a. Foreign key b. Native key c. Composite key d. Primary key

Ans:ndash; d,ndash; d


When you insert an excel file into a word document. The data are
Options: a. Hyperlinked placed in a word table b. Linked c. Embedded d. Use the word menu bar and toolbars

Ans:#8211; b,#8211; b


. Ctrl + M
Options: New Document B. Close Document C. Right Indent D. Left Indent

Ans:– D ,


Scissoring enables
Options: a part of data to be displayed,    entire data to be displayed,    full data display on full area of screen,    no data to be displayed

Ans:A ,A


Vision sensors:
Options: will remain very costly,    can not improve much in the next decade,    will more closely match the capabilities of the human eye,    All of the above

Ans:C ,C


. Which of the following options in the printer dialog box would you select to print slides 5 and 12 in a presentation?
Options: a. Slides b. Custom shows c. Current slide d. All

Ans:6 – A ,6 – A


Which command is used to upgrade an IOS on a Cisco router?
Options: copy tftp run,    copy tftp start,    config net,    copy tftp flash

Ans:D ,D


An IBM System/38 represents the computer class of:
Options: small-scale computer,    medium-scale computer,    large-scale computer,    super computer

Ans:A ,A


Special programs that assist programmers are called:
Options: heuristic processors,    symbolic programmers,    intelligent programming tools,    program recognizers

Ans:C ,C


. The first Macintosh computer was from
Options: A) First generation B) Second generation C) Third generation D) Fourth generation

Ans:D,D


. Which file keeps commands to execute automatically when OS is started?
Options: a. command . com b. any batch file c. autoexec.bat d. config.sys

Ans:9 – c ,9 – c


What will be the output of the program (sample.c) given below if it is executed from the command line (turbo c under DOS)? cmd> sample Good Morning /* sample.c */ #include<stdio.h> int main(int argc, char *argv[]) { printf("%d %s", argc, argv[1]); return 0; }
Options: 3 Good,    2 Good,    Good Morning,    3 Morning

Ans:A ,A


. A(n) _____ is an image control that displays in the background of a page on a form or report.
Options: a. legend b. icon c. logo d. watermark

Ans:9 – d ,9 – d


Which of the following statement obtains the remainder on dividing 5.5 by 1.3 ?
Options: rem = (5.5 % 1.3),    rem = modf(5.5, 1.3),    rem = fmod(5.5, 1.3),    Error: we can't divide

Ans:C ,C


The ATAPI compliance is stands for?
Options: CDROM,    Bus mastering,    Mass storage device,    All of the above

Ans:C ,C


1 Microfarad is the same as:
Options: 1 millionth of a picofarad,    1000 millifarads,    1 million picofarads,    1 million farads

Ans:C ,C


. Which of the following is considered first computer in the world?

Options: A) Z3 B) ABC C) Mark I D) None of abobe

Ans:C,C


A database management system (DBMS) is a:
Options: hardware system used to create, maintain, and provide controlled access to a database.,    hardware system used to create, maintain, and provide uncontrolled access to a database.,    software system used to create, maintain, and provide controlled access to a database.,    software system used to create, maintain, and provide uncontrolled access to a database.

Ans:C ,C


Impact printers
Options: strike a ribbon against the paper to produce character images,    include ink-jet and thermal devices,    are more expensive than Laser printers,    use optical technology

Ans:A ,A


. Unlike text data type, this can store up to maximum of 65, 535 characters.
Options: a. Memo b. Data/time c. Number d. All of above

Ans:8 – a ,8 – a


A solenoid:
Options: can be used only in de circuits,    is spring operated,    is widely used in industrial automation,    is related to an aneroid

Ans:C ,C


. Which button might you find in a windows title bar?
Options: a. Close button b. Maximize button c. Minimize button d. All of the above

Ans:3 – d ,3 – d


If you need to double underline a word, how will you do that?
Options:  A) Go to Format menu and then Font option. Open Underline Style and choose Double Underline, B) From Format menu choose Font option and then from Font tab open Underline Style and select Double Underline, C) Select the text then choose Format >> Font and on Font tab open Underline Style and choose Double Underline, D) Click double underline tool on formatting toolbar,

Ans:-C,-C


An MIS can be developed by
Options: a fire department,    a college testing service,    an ocean transportation company,    All of the above

Ans:D ,D


The MODE command of MS-DOS is used to
Options: display information about several types of devices installed in your computer,    provide various types of control over your printers,    make changes of the current display,    All of the above

Ans:D ,D


Which of the following memories needs refresh?
Options: DRAM B. SRAM C. ROM D. All of above

Ans:– A ,


Who made the statement "if a robot can do a job, a person should not be doing it"?
Options: Prof. F. A. Fisher of Britain,    Ron Albo of Shugart Associates, California,    Prof. Meredith Turing, London University,    John Smith, USA

Ans:B ,B


A variable that has no physical meaning and is used to obtain an initial basic feasible solution to a linear programming problem is known as:
Options: basis,    algorithm,    artificial variable,    basic variable

Ans:D ,D


A turnaround document can be a (n)
Options: punched card,    OCR document,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


Which command is used to delete all files in the current directory as well as all files and sub-directories in its subdirectories?
Options: rm *,    rm -r *,    rm all,    rm *.*

Ans:B ,B


. In Computer System Memory management operations are performed by
Options: User B. Hardware       C. Programmer D. Operating system

Ans:– D ,


Goals for the design of the logical schema include
Options: avoiding data inconsistency,    being able to construct queries easily,    being able to access data efficiently,    All of the above

Ans:D ,D


Which option will be used with disk free command to include the total amount of disk space in the file system?
Options: -t,    -tt,    -4,    -i

Ans:A ,A


A snowflake schema is which of the following types of tables?
Options: Fact,    Dimension,    Helper,    All of the above

Ans:D ,D

www.000webhost.com